![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
SQL Trace FunctionalityOnce SQL Trace is enabled, it gathers the following information:
SQL Trace puts this information into a trace file in an unreadable form. You then use the Oracle program TKPROF to format the trace information into useful, understandable data. TKPROF FunctionalityYou use the Oracle program TKPROF to convert the SQL Trace information into data that is formatted to be understood by human beings. By specifying certain options, you can customize the output of TKPROF to some degree. TKPROF is invoked with the following syntax: TKPROF inputfile outputfile [ Optional Parameters ] In this syntax, inputfile is the data file generated by SQL Trace and outputfile is the name of the file to which you want the output of TKPROF to be written. The optional parameters for KTPROF are as follows:
With these options, SQL Trace can provide an abundance of data that can help you analyze your SQL statements. The following section examines some of the data SQL Trace provides.
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |